Monte Carlo Simulation using Excel
نویسندگان
چکیده
A Monte-Carlo Simulation using Excel Spreadsheet has been used to determine the reliability of a geothermal power plant. This simulation technique utilizes the powerful mathematical and statistical capabilities of Excel. Simulation time is dependent on the complexity of the system, computer speed and the accuracy desired, so a simulation may range from a few minutes to a few hours.
منابع مشابه
Assessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملMonte Carlo Simulation of Multiplication Factor in PIN In0.52Al0.48As Avalanche Photodiodes
In this paper, we calculate electron and hole impactionization coefficients in In0.52Al0.48As using a Monte Carlo modelwhich has two valleys and two bands for electrons and holesrespectively. Also, we calculate multiplication factor for electronand hole initiated multiplication regimes and breakdown voltagein In0.52Al0.48As PIN avalanche photodiodes. To validate themodel, we compare our simulat...
متن کاملSiemens primus accelerator simulation using EGSnrc Monte Carlo code and gel dosimetry validation with optical computed tomography system by EGSnrc code
Monte Carlo method is the most accurate method for simulation of radiation therapy equipment. The linear accelerators (linac) are currently the most widely used machines in radiation therapy centers. Monte Carlo modeling of the Siemens Primus linear accelerator in 6 MeV beams was used. Square field size of 10 × 10 cm2 produced by the jaws was compared with TLD. Head simulation of Siemens accele...
متن کاملUncertainties due to Fuel Heating Value and Burner Efficiency on Performance Functions of Turbofan Engines Using Monte Carlo Simulation
In this paper, the impacts of the uncertainty of fuel heating value as well as the burner efficiency on performance functions of a turbofan engine are studied. The mean value and variance curves for thrust, thrust specific fuel consumption as well as propulsive, thermal and overall efficiencies are drawn and analyzed, considering the aforementioned uncertainties based on various Mach numbers at...
متن کاملMonte Carlo simulation of parameter confidence intervals for non-linear regression analysis of biological data using Microsoft Excel
This study describes a method to obtain parameter confidence intervals from the fitting of non-linear functions to experimental data, using the SOLVER and Analysis ToolPaK Add-In of the Microsoft Excel spreadsheet. Previously we have shown that Excel can fit complex multiple functions to biological data, obtaining values equivalent to those returned by more specialized statistical or mathematic...
متن کامل